
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_SearchData] ( @Title VARCHAR(50) )
AS 
    IF @Title <> '' 
        SELECT  ID ,
                Title ,
                Detail
        FROM    dbo.SAP_Knowledge
        WHERE   CONTAINS ( Title, @Title )
    ELSE 
        SELECT  ID ,
                Title ,
                Detail
        FROM    dbo.SAP_Knowledge
GO
